data base management system (DBMS) Practice Questions Answers Test with Solutions & More Shortcuts

Question : 16

Append from command is used to

a) Add records from information in an array

b) Adds records from a file

c) Add records from a variable

d) Add records from stock

Question : 17

A set of programs that handle firm’s data base responsibilities is called a

a) Database Management System (DBMS)

b) Database Processing System (DBPS)

c) Data Management System (DMS)

d) All of above

Question : 18

How do you filter by selection?

a) Right click the field value and select filter by selection from the shortcut menu

b) Find and double click the value on which you want to base the filter

c) Find and select the value on which you want to base the filter and select tools>filter by selection from the menu

d) None of the above

Question : 19

It shows the appearance and layout of a report, table or form in order to confirm what will be printed.

a) Datasheet view

b) Design view

c) Print preview

d) Layout preview

Question : 20

In access, the best types of queries to use for data analysis are:

a) Select queries

b) Parameter queries

c) Action queries

d) All of the above